You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's +pride +inc' IN BOOLEAN MODE) and  act='1' 
      group by shop
     ) tc
    ' at line 3